﻿CREATE TABLE [dbo].[Role] (
    [Id]           UNIQUEIDENTIFIER CONSTRAINT [DF_Role_Id] DEFAULT (newid()) NOT NULL,
    [Name]         NVARCHAR (128)   NOT NULL,
    [DateActive]   DATE             CONSTRAINT [DF_Role_DateActive] DEFAULT (getdate()) NOT NULL,
    [DateInactive] DATE             NULL,
    CONSTRAINT [PK_Role] PRIMARY KEY CLUSTERED ([Id] ASC)
);




GO
CREATE NONCLUSTERED INDEX [IX_Role]
    ON [dbo].[Role]([Name] ASC);

